Import Applicants Data
The second way of adding Applicants is by importing them via CSV or Excel. Down below are two downloadable files. Please click on them to download the respective file.
Once you open the file, you will see 2 rows. Row 1 contains all the headers necessary for the importation to work correctly.
On the second row you will see an example applicant. Please use this as a guide for all your other applicants.
You may delete any column if you do not wish to import that specific information.
Do NOT leave any empty rows between applicants. It will cause the importer to import an Empty applicant as shown below.


If you wish to add a field, please view the table below for all acceptable column names.
The column names can be inputted with Upper case letters and spaces. EX: "First Name" is acceptable and will be read as "firstname".
Acceptable Fields
| Field | Acceptable Column Names |
|---|---|
| First/Middle Name |
|
| Last Name |
|
| Title |
|
| Rank |
|
| Address Line 1 |
|
| Address Line 2 |
|
| City |
|
| State/Province |
|
| Zipcode/Postal Code |
|
| Country |
|
| Issue Date |
|
| Expiration Date |
|
| Hire Date |
|
| Date of Birth |
|
| Height |
|
| Weight |
|
| Eye Color |
|
| Hair Color |
|
| Sex |
|
| Badge No. |
|
| Helpline |
|
| Supervisor Name |
|
| Supervisor Title |
|
| Additional Date Field 1 |
|
| Additional Date Field 2 |
|
| Additional Date Field 3 |
|
| Additional Text Field 1 |
|
| Additional Text Field 2 |
|
| Additional Text Field 3 |
|
| Additional Text Field 4 |
|
| Additional Text Field 5 |
|
| Endorsement 1 |
|
| Endorsement 2 |
|
| Endorsement 3 |
|
| Endorsement 4 |
|
| Endorsement 5 |
|
| URL QRCode |
|
Importing Restrictions
Certain Fields require specific information or it will not be imported. Down below is another table with all the fields and their specific information.
Just like the Headers, these values are not restricted by case sensitivity, but they are space sensitive. EX: "ReDaubUrn" will work but "Red Auburn" will not work.
| Field | Values Allowed |
|---|---|
| Country | United States
|
| State | United States
|
| Province | Canada
|
| Eye |
|
| Hair |
|
| Sex |
|
| Height | Height in Inches
|
| Issue Date |
|
| Expiration Date |
|
| Hire Date |
|
| Date of Birth |
|
| Endorsements |
|
| URL QRCode | Any website link but it requires proper format
|
Importing Applicants
As you finish inputting all your applicant's information, please save the file and go back to the GETIDPaaS Website.
Please click on Enter Data from the main page. Then on the left Navigation, click on the Tab "Import Applicant Data"
Another drop-down list like on the Enter Applicant Data will appear. All your current IDs will be there. Please select one of your ID's. A button/upload link will then appear. There you can either select the file from your file explorer or drag and drop it there. Your applicants will then begin to be imported.
If an Badge ID of an applicant on the Import Sheet matches with an ID with an Applicant on the Review Applicants page, it will overwrite all the information of the Applicant with the information from the Import Sheet. Please note that if there are more than one applicant with the same Badge ID in the Review Applicant page, it will overwrite the most recently modified Applicant.

After your applicants are imported, the total amount of cards imported will be displayed.

If the importer ran into any issues, it will display a new button at the bottom called "Summary of Errors".

Clicking the button will then open up a Summary of all the errors the importer had while importing your Applicants. You can find out which Applicant and what the issue was. You can use the row number to determine which applicant it was.

Once you have finished importing all of your applicants, you can go to Review Applicants if you would like to make any changes there. You can go to Review Applicants by clicking the button at the bottom or by clicking Review Applicants in the left navigation.